| Server IP : 121.121.20.254 / Your IP : 216.73.216.202 Web Server : Microsoft-IIS/10.0 System : Windows NT WEB-SERVER 10.0 build 20348 (Windows Server 2022) AMD64 User : IUSR ( 0) PHP Version : 8.3.28 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Program Files/LibreOffice/help/en-US/text/sbasic/shared/ |
Upload File : |
<!DOCTYPE html>
<html lang="en-US" dir="ltr">
<head>
<base href="../../../../">
<noscript><meta http-equiv="refresh" content="0; URL=../../../../en-US/noscript.html"></noscript>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>DateAdd Function</title>
<link rel="shortcut icon" href="media/navigation/favicon.ico">
<link type="text/css" href="normalize.css" rel="Stylesheet">
<link type="text/css" href="prism.css" rel="Stylesheet">
<link type="text/css" href="default.css" rel="Stylesheet">
<script type="text/javascript" src="polyfills.js"></script><script type="text/javascript" src="languages.js"></script><script type="text/javascript" src="en-US/langnames.js"></script><script type="text/javascript" src="flexsearch.debug.js"></script><script type="text/javascript" src="prism.js"></script><script type="text/javascript" src="help2.js" defer></script><script type="text/javascript" src="a11y-toggle.js" defer></script><script type="text/javascript" src="paginathing.js" defer></script><script type="text/javascript" src="en-US/bookmarks.js" defer></script><script type="text/javascript" src="en-US/contents.js" defer></script><script type="text/javascript" src="help.js" defer></script><meta name="viewport" content="width=device-width,initial-scale=1">
</head>
<body>
<header id="TopLeftHeader"><a class="symbol" href="en-US/text/shared/05/new_help.html"><div></div></a><a class="logo" href="en-US/text/shared/05/new_help.html"><p dir="auto">LibreOffice 24.2 Help</p></a><div class="dropdowns"><div class="modules">
<button type="button" data-a11y-toggle="modules-nav" id="modules" aria-haspopup="true" aria-expanded="false" aria-controls="modules-nav">Module</button><nav id="modules-nav" hidden=""></nav>
</div></div></header><aside class="leftside"><input id="accordion-1" name="accordion-menu" type="checkbox"><label for="accordion-1" dir="auto">Contents</label><div id="Contents" class="contents-treeview"></div></aside><div id="SearchFrame"><div id="Bookmarks">
<input id="search-bar" type="search" class="search" placeholder="Search in bookmarks for chosen module" dir="auto"><div class="nav-container" tabindex="0"><nav class="index" dir="auto"></nav></div>
</div></div>
<div id="DisplayArea" itemprop="softwareHelp" itemscope="true" itemtype="http://schema.org/SoftwareApplication">
<a name="dateadd"></a>
<a name="bm_id6269417"></a>
<meta itemprop="keywords" content="DateAdd function">
<h1 id="par_idN10548" dir="auto">DateAdd Function</h1>
<p id="par_idN10558" class="paragraph" dir="auto">Adds a date or time interval to a given date a number of times and returns the resulting date.</p>
<div class="embedded">
<a name="functsyntax"></a>
<h3 id="hd_id061420171139089682" dir="auto">Syntax:</h3>
</div>
<div class="bascode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Click on text to copy to clipboard"><pre dir="auto"><code class="language-visual-basic line-numbers">
DateAdd (interval As String, number As Long, date As Date) As Date
</code></pre></div>
<h3 id="par_idN1061E" dir="auto">Return value:</h3>
<p id="par_idN10622" class="paragraph" dir="auto">A Variant containing a date.</p>
<div class="embedded">
<a name="functparameters"></a>
<h3 id="hd_id061420171139084157" dir="auto">Parameters:</h3>
</div>
<p id="par_idN10629" class="paragraph" dir="auto"><span class="emph">interval</span> - A string expression from the following table, specifying the date or time interval.</p>
<a name="datetable"></a>
<table border="1" class="" cellpadding="0" cellspacing="0">
<tr>
<th rowspan="" colspan="" class="tableheadcell" dir="auto">
<p id="par_idN10636" class="tableheadintable" dir="auto">interval (string value)</p>
</th>
<th rowspan="" colspan="" class="tableheadcell" dir="auto">
<p id="par_idN1063C" class="tableheadintable" dir="auto">Explanation</p>
</th>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10643" class="tablecontentintable" dir="auto">yyyy</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10649" class="tablecontentintable" dir="auto">Year</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10650" class="tablecontentintable" dir="auto">q</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10656" class="tablecontentintable" dir="auto">Quarter</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN1065D" class="tablecontentintable" dir="auto">m</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10663" class="tablecontentintable" dir="auto">Month</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN1066A" class="tablecontentintable" dir="auto">y</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10670" class="tablecontentintable" dir="auto">Day of year</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10677" class="tablecontentintable" dir="auto">w</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN1067D" class="tablecontentintable" dir="auto">Weekday</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10684" class="tablecontentintable" dir="auto">ww</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN1068A" class="tablecontentintable" dir="auto">Week of year</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10691" class="tablecontentintable" dir="auto">d</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10697" class="tablecontentintable" dir="auto">Day</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN1069E" class="tablecontentintable" dir="auto">h</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN106A4" class="tablecontentintable" dir="auto">Hour</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN106AB" class="tablecontentintable" dir="auto">n</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN106B1" class="tablecontentintable" dir="auto">Minute</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN106B8" class="tablecontentintable" dir="auto">s</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN106BE" class="tablecontentintable" dir="auto">Second</p>
</td>
</tr>
</table>
<br>
<p id="par_idN106C1" class="paragraph" dir="auto"><span class="emph">number</span> - A numerical expression specifying how many times the <span class="literal">interval</span> value will be added when positive or subtracted when negative.</p>
<p id="par_idN106C4" class="paragraph" dir="auto"><span class="emph">date</span> - A given date or the name of a Variant variable containing a date. The <span class="literal">interval</span> value will be added <span class="literal">number</span> times to this date.</p>
<div class="embedded">
<a name="DateLiterals"></a>
<p id="par_id151616083357363" class="paragraph" dir="auto">Date literals allow to specify unambiguous date variables that are independent from the current language. Literals are enclosed between hash signs <span class="literal">#</span>. Possible formats are:</p>
<ul itemprop="Unordered" itemscope="true" itemtype="http://schema.org/ItemList" dir="auto">
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id41616083766108" class="listitem" dir="auto"><span class="literal">#yyyy-mm-dd#</span></p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id271616083874773" class="listitem" dir="auto"><span class="literal">#mm/dd/yyyy#</span></p>
</li>
</ul>
</div>
<div class="embedded">
<a name="functexample"></a>
<h3 id="hd_id061420171139088233" dir="auto">Example:</h3>
</div>
<div class="bascode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Click on text to copy to clipboard"><pre dir="auto"><code class="language-visual-basic line-numbers">
Sub example_dateadd
MsgBox DateAdd("m", 1, #1/31/2004#) &" - "& DateAdd(date:=#2005-01-31#, interval:="m", number:=1)
End Sub
</code></pre></div>
</div>
<div id="DonationFrame"></div>
<footer><div id="DEBUG" class="debug">
<h3 class="bug">Help content debug info:</h3>
<p dir="auto">This page is: <a href="https://opengrok.libreoffice.org/xref/help/source/text/sbasic/shared/03030110.xhp" target="_blank">/text/sbasic/shared/03030110.xhp</a></p>
<p dir="auto">Title is: DateAdd Function</p>
<p id="bm_module" dir="auto"></p>
<p id="bm_system" dir="auto"></p>
<p id="bm_HID" dir="auto"></p>
</div></footer>
</body>
</html>